
   create external table  jms_dwd.dwd_yl_oms_order_performance_base_dt
(
  ID                     bigint comment '主键ID',
  WAYBILL_NO             string comment '运单号',
  CONTACT_BEGIN_TIME     TIMESTAMP comment '电联开始时间',
  CONTACT_DURATION       bigint comment '电联时长',
  DELIVERY_STAFF_NAME    string comment '派件业务员',
  DELIVERY_STAFF_CODE    string comment '派件业务员CODE',
  INPUT_TIME             TIMESTAMP comment '录入时间',
  CALL_REASON            string comment '失败原因',
  CALL_TYPE              tinyint comment '通话类型 1、呼出、2、呼入、3、呼入呼出（回溯）',
  PERFORMANCE_MARK       int comment '履约标记',
  RINGING_TIME           int comment '振铃时长'
) comment '履约电联记录表'

 PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
	 stored as parquet
    LOCATION
   '/dw/hive/jms_dwd.db/external/dwd_yl_oms_order_performance_base_dt';
